Interview Questions

1. How many types of authentication are provided in SQL Server

Options:

a. 1

b. 3

c. 2

Reveal Answer

2. How is a named instance of SQL Server identified?

Options:

a. By the Network name of the computer

b. By the instance name

c. By both the instance name and the network name of the computer

Reveal Answer

3. Can we install more than one instance of the SQL Server?

Options:

a. Yes

b. No

Reveal Answer

4. What kind of data does nchar data type hold?

Options:

a. Unicode

b. Non-unicode

Reveal Answer

5. Which of the following is true regarding a bit data type?

Options:

a. It is an integer data type

b. It can hold either a 0 or 1 value

c. It can hold either true or false value

Reveal Answer

6. Can we create a user defined data type?

Options:

a. Yes

b. No

Reveal Answer

7. How many system databases are present in SQL Server

Options:

a. 3

b. 4

Reveal Answer

8. The SQL Server cannot start if which of the following databases is not present?

Options:

a. Model

b. Master

c. Msdb

Reveal Answer

9. Which system database functions as a template database?

Options:

a. Master

b. Msdb

c. Model

d. Tempdb

Reveal Answer

10. Which database is recreated everytime the SQL Server starts?

Options:

a. Master

b. Msdb

c. Model

d. Tempdb

Reveal Answer

11. The tempdb database is created from the model dtabase

Options:

a. true

b. false

Reveal Answer

12. Which of the following data type stores variable length characters?

Options:

a. varchar

b. nvarchar

Reveal Answer

13. ________ language allows u to create,alter and delete database objects

Options:

a. DML

b. DDL

c. DCL

d. DQL

Reveal Answer

14. ______ an organized form of data for easy access, storing,retrieval and managing of data.

Options:

a. FIELD

b. DATA

c. RECORD

d. DATABASE

Reveal Answer

15. _______is a combination of fields which uniquely specify a row.

Options:

a. PRIMARY KEY

b. FOREIGN KEY

c. INSERT KEY

d. JOIN

Reveal Answer

16. ______ is a standard language used to perform tasks such as to retrieve, update, insert and delete of data from a database

Options:

a. DQL

b. SQL

c. RDBMS

d. DATABASE

Reveal Answer

17. _______is a set of data that are organized in a model with Columns and Rows.

Options:

a. DATA

b. FIELD

c. TABLE

d. RECORD.

Reveal Answer

18. A table contains specified number of column called ___________

Options:

a. FIELD

b. DATA

c. RECORD

d. TABLE

Reveal Answer

19. A field can have any number of rows which is known as

Options:

a. DATA

b. RECORD

c. DATABASE

d. FIELD

Reveal Answer

20. What are the disadvantages of File Management System

Options:

a. EFFICIENT DATA STORAGE

b. SECURITY

c. DATA INCONSISTENCY

d. NON OF THESE

Reveal Answer

21. What are the advantages of Data Base Management System

Options:

a. DATA REDUNDANCY

b. DIFFICULTY IN ACCESSING DATA

c. EFFICIENT DATA STORAGE

d. SECURITY PROBLEM

Reveal Answer

22. Which level is the lowest level of abstraction

Options:

a. LOGICAL LEVEL

b. PHYSICAL LEVEL

c. VIEW LEVEL

d. ALL OF THESE

Reveal Answer

23. Which level is the user's view of data base

Options:

a. VIEW LEVEL

b. LOGICAL LEVEL

c. PHYSICAL LEVEL

d. NON OF THESE

Reveal Answer

24. Which was the first data base model

Options:

a. RELATIONAL MODEL

b. HIERARICHICAL MODEL

c. NETWORK MODEL

d. RELATION MODEL

Reveal Answer

25. A named property or characteristic of an entity is

Options:

a. ENTITY

b. ATTRIBUTE

c. ENTITY SET

d. DATA

Reveal Answer

26. _____________ is the step by step process of decomposing the data into tables and establishing a Relationship between them

Options:

a. DATABASE

b. NORMALIZATION

c. RECORD

d. TABLE

Reveal Answer

27. ___________ statement is used to retrieve data in the database.

Options:

a. UPDATE

b. DELETE

c. INSERT

d. SELECT

Reveal Answer

Interview Questions and Answer

1. How many types of authentication are provided in SQL Server

2. How is a named instance of SQL Server identified?

3. Can we install more than one instance of the SQL Server?

4. What kind of data does nchar data type hold?

5. Which of the following is true regarding a bit data type?

6. Can we create a user defined data type?

7. How many system databases are present in SQL Server

8. The SQL Server cannot start if which of the following databases is not present?

9. Which system database functions as a template database?

10. Which database is recreated everytime the SQL Server starts?

11. The tempdb database is created from the model dtabase

12. Which of the following data type stores variable length characters?

13. ________ language allows u to create,alter and delete database objects

14. ______ an organized form of data for easy access, storing,retrieval and managing of data.

15. _______is a combination of fields which uniquely specify a row.

16. ______ is a standard language used to perform tasks such as to retrieve, update, insert and delete of data from a database

17. _______is a set of data that are organized in a model with Columns and Rows.

18. A table contains specified number of column called ___________

19. A field can have any number of rows which is known as

20. What are the disadvantages of File Management System

21. What are the advantages of Data Base Management System

22. Which level is the lowest level of abstraction

23. Which level is the user's view of data base

24. Which was the first data base model

25. A named property or characteristic of an entity is

26. _____________ is the step by step process of decomposing the data into tables and establishing a Relationship between them

27. ___________ statement is used to retrieve data in the database.

Packages

Trending Certification Courses:

Microsoft Mock Exams:

Other links

About

Resources